<% connstr = "DBQ=" + server.mappath("job/DataBase/job.asp") + ";DRIVER={Microsoft Access Driver (*.mdb)}" Set conn=Server.createobject("ADODB.CONNECTION") conn.Open connstr Function CloseDatabase() conn.Close Set conn=Nothing End Function %><% set rs=server.createobject("adodb.recordset") sql="select * from company" rs.open sql,conn,1,1 r1=rs.recordcount rs.close set rs=nothing set rs=server.createobject("adodb.recordset") sql="select * from zp order by id desc" rs.open sql,conn,1,1 jobnum=rs.recordcount %> <% do while not rs.eof %> <% c=c+1 rs.movenext if c>=3 then exit do loop rs.close set rs=nothing %>

▓ 公司名称	▓ 招聘职位	▓ 发布日期
" target="_blank"> <% if len(rs("cname"))>15 then%> <%=Left(rs("cname"),13)%>... <% else%> <%=rs("cname")%> <%end if%>	&id=<%=rs("id")%>" target="_blank"><%=rs("job")%>	<%=rs("idate")%>

<% set rs=server.createobject("adodb.recordset") sql="select * from person" rs.open sql,conn,1,1 r2=rs.recordcount rs.close set rs=nothing set rs=server.createobject("adodb.recordset") sql="select * from person where job<>'""' order by id desc" rs.open sql,conn,1,1 jlnum=rs.recordcount %> <% do while not rs.eof %> <% p=p+1 rs.movenext if p>=3 - temppersoncount then exit do loop rs.close set rs=nothing set rs=server.createobject("adodb.recordset") sql="select * from pmailbox" rs.open sql,conn,1,1 pmailnum=rs.recordcount rs.close set rs=nothing set rs=server.createobject("adodb.recordset") sql="select * from cmailbox" rs.open sql,conn,1,1 cmailnum=rs.recordcount rs.close set rs=nothing %>

<% set rs=server.createobject("adodb.recordset") sql="select top 3 * from person where pok=1 and job<>'' order by id desc" rs.open sql,conn,1,1 temppersoncount = rs.recordcount rs.close set rs = nothing set rs=server.createobject("adodb.recordset") sql="select * from person" rs.open sql,conn,1,1 r2=rs.recordcount rs.close set rs=nothing set rs=server.createobject("adodb.recordset") sql="select * from person where job<>'""' order by id desc" rs.open sql,conn,1,1 jlnum=rs.recordcount %>
▓ 姓 名	▓ 性 别	▓ 学 历	▓ 应聘岗位
" target="_blank"><%=rs("iname")%>	[<%=rs("sex")%>]	[<%=rs("edu")%>]	" target="_blank"><%=rs("job")%>